﻿using System;
using System.Collections.Generic;
using System.Data.OracleClient;
using System.Linq;
using System.Text;
using OracleCommandVisualizer;

namespace Tester
{
    class Program
    {
        static void Main(string[] args)
        {
            OracleCommand cmd = new OracleCommand();
            cmd.CommandText = 
                "SELECT * FROM Boo WHERE C1 = :p1 AND C2 = :p2 AND C3 = :p3 AND C4 = :p4";
            cmd.Parameters.Add("p1", OracleType.Number).Value = "1234";
            cmd.Parameters.Add("p2", OracleType.DateTime).Value = DateTime.Today;
            cmd.Parameters.Add("p3", OracleType.NVarChar).Value = "Darkthread";
            cmd.Parameters.Add("p4", OracleType.NClob).Value = "Text";
            //DebuggerVisualizer.TestShowVisualizer(cmd);
            Console.Read();
        }
    }
}
